////////////////////////////////////////////////////////////////////////////////
// Copyright 2009 CORE Solutions Limited
// All rights reserved.
// PROPRIETARY AND CONFIDENTIAL INFORMATION.
// Use is subject to license terms.
//
// FUNCTION ID      :   XLS
// AUTHOR           :   Saint Peng 
// DATE CREATE      :   2009/05/13
// DESCRIPTION      :   a SCHEMA file for the function, XLS
//                  :   
//                  :   
//                  :   
//
// MODIFICATION HISTORY:
// DATE         AUTHOR          VERSION NO.         COMMENT
// -----------  --------------  ------------------  -------------------
// 2009/05/13   Saint Peng      1.0                 source is generated.
//
//
//
////////////////////////////////////////////////////////////////////////////////

package com.erp.app.common.xls.schema;

import com.erp.framework.model.schema.MetaData;
import com.erp.framework.model.schema.TableSchema;

/**
* <p>A <strong>Schema</strong> stores the table meta information.
* The main purpose for this class is to validate the lengths of UniCode Characters,
* and notify the database to store UniCode characters from web browsers.
*
* @author          Saint Peng 
* @version 1.0     2009/05/13
* @since           FrameWork 1.0
*
*/
public class XlsCellSchema extends TableSchema {

	public static final String TABLE_NAME = "T_XLS_CELL";

	public XlsCellSchema(){

		MetaData md = null;

		md = new MetaData();
		md.setColumnName("COMPANY_CODE");
		md.setVoPropertyName("companyCode");
		md.setColumnTitle("COMPANY_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_CELL_COMPANY_CODE");
		md.setWebLabelName("DEF CELL COMPANY CODE");
		ts.add(md);
		
		md = new MetaData();
		md.setColumnName("CELL_TYPE");
		md.setVoPropertyName("cellCellType");
		md.setColumnTitle("CELL_TYPE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_CELL_CELL_TYPE");
		md.setWebLabelName("DEF CELL CELL_TYPE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COMPANY_CODE");
		md.setVoPropertyName("lblSrchCompanyCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_COMPANY_CODE");
		md.setVoPropertyName("lblGridCompanyCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_COMPANY_CODE");
		md.setWebLabelName("DEF GRID COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("MENU_ID");
		md.setVoPropertyName("menuId");
		md.setColumnTitle("MENU_ID");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_CELL_MENU_ID");
		md.setWebLabelName("DEF CELL MENU ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_MENU_ID");
		md.setVoPropertyName("lblSrchMenuId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_MENU_ID");
		md.setWebLabelName("DEF SRCH MENU ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_MENU_ID");
		md.setVoPropertyName("lblGridMenuId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_MENU_ID");
		md.setWebLabelName("DEF GRID MENU ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("FUN_ID");
		md.setVoPropertyName("funId");
		md.setColumnTitle("FUN_ID");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_CELL_FUN_ID");
		md.setWebLabelName("DEF CELL FUN ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_FUN_ID");
		md.setVoPropertyName("lblSrchFunId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_FUN_ID");
		md.setWebLabelName("DEF SRCH FUN ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_FUN_ID");
		md.setVoPropertyName("lblGridFunId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_FUN_ID");
		md.setWebLabelName("DEF GRID FUN ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("ACR_ID");
		md.setVoPropertyName("acrId");
		md.setColumnTitle("ACR_ID");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_CELL_ACR_ID");
		md.setWebLabelName("DEF CELL ACR ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_ACR_ID");
		md.setVoPropertyName("lblSrchAcrId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_ACR_ID");
		md.setWebLabelName("DEF SRCH ACR ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_ACR_ID");
		md.setVoPropertyName("lblGridAcrId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_ACR_ID");
		md.setWebLabelName("DEF GRID ACR ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("VER_ID");
		md.setVoPropertyName("verId");
		md.setColumnTitle("VER_ID");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_CELL_VER_ID");
		md.setWebLabelName("DEF CELL VER ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_VER_ID");
		md.setVoPropertyName("lblSrchVerId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_VER_ID");
		md.setWebLabelName("DEF SRCH VER ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_VER_ID");
		md.setVoPropertyName("lblGridVerId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_VER_ID");
		md.setWebLabelName("DEF GRID VER ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("SQL_LINE_NO");
		md.setVoPropertyName("cellSqlLineNo");
		md.setColumnTitle("SQL_LINE_NO");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(10);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_CELL_SQL_LINE_NO");
		md.setWebLabelName("DEF CELL SQL LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_SQL_LINE_NO");
		md.setVoPropertyName("lblSrchCellSqlLineNo");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_SQL_LINE_NO");
		md.setWebLabelName("DEF SRCH SQL LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_SQL_LINE_NO");
		md.setVoPropertyName("lblGridCellSqlLineNo");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_SQL_LINE_NO");
		md.setWebLabelName("DEF GRID SQL LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("COL_NAME");
		md.setVoPropertyName("cellColName");
		md.setColumnTitle("COL_NAME");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(200);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(200);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_CELL_COL_NAME");
		md.setWebLabelName("DEF CELL COL NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COL_NAME");
		md.setVoPropertyName("lblSrchCellColName");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COL_NAME");
		md.setWebLabelName("DEF SRCH COL NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_COL_NAME");
		md.setVoPropertyName("lblGridCellColName");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_COL_NAME");
		md.setWebLabelName("DEF GRID COL NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("IS_MERGE");
		md.setVoPropertyName("cellIsMerge");
		md.setColumnTitle("IS_MERGE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_CELL_IS_MERGE");
		md.setWebLabelName("DEF CELL IS MERGE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_IS_MERGE");
		md.setVoPropertyName("lblSrchCellIsMerge");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_IS_MERGE");
		md.setWebLabelName("DEF SRCH IS MERGE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_IS_MERGE");
		md.setVoPropertyName("lblGridCellIsMerge");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_IS_MERGE");
		md.setWebLabelName("DEF GRID IS MERGE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("MERGE_COL_NAME");
		md.setVoPropertyName("cellMergeColName");
		md.setColumnTitle("MERGE_COL_NAME");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_CELL_MERGE_COL_NAME");
		md.setWebLabelName("DEF CELL MERGE COL NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_MERGE_COL_NAME");
		md.setVoPropertyName("lblSrchCellMergeColName");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_MERGE_COL_NAME");
		md.setWebLabelName("DEF SRCH MERGE COL NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_MERGE_COL_NAME");
		md.setVoPropertyName("lblGridCellMergeColName");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_MERGE_COL_NAME");
		md.setWebLabelName("DEF GRID MERGE COL NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("STY_DTL_ROW");
		md.setVoPropertyName("cellStyDtlRow");
		md.setColumnTitle("STY_DTL_ROW");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(10);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_CELL_STY_DTL_ROW");
		md.setWebLabelName("DEF CELL STY DTL ROW");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_STY_DTL_ROW");
		md.setVoPropertyName("lblSrchCellStyDtlRow");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_STY_DTL_ROW");
		md.setWebLabelName("DEF SRCH STY DTL ROW");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_STY_DTL_ROW");
		md.setVoPropertyName("lblGridCellStyDtlRow");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_STY_DTL_ROW");
		md.setWebLabelName("DEF GRID STY DTL ROW");
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_CELL_SELECT");
		md.setWebLabelName("DEF CELL SELECT");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_CELL_DELETE");
		md.setWebLabelName("DEF CELL DELETE");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

	}

}